﻿
using SqlSugar;
using System;
using System.Linq;
using ERP1.Entity;
namespace OrmTest
{
    public class Unitadfasfafays
    {
        public static void Init() 
        {
            SqlSugarClient db = NewUnitTest.Db;

            db.CurrentConnectionConfig.MoreSettings = new ConnMoreSettings()
            {
                TableEnumIsString = true                //使用枚举名，而不是枚举的HashCode
            };
            if (!db.DbMaintenance.IsAnyTable("t_order", false))
            {
                db.Ado.ExecuteCommand("CREATE TABLE `t_order` (\r\n  `SaleNo` varchar(50) NOT NULL,\r\n  `BusinessTeamId` char(32) NOT NULL,\r\n  `WebsiteId` char(32) NOT NULL,\r\n  `BusinesserId` char(32) DEFAULT NULL,\r\n  `CustomerId` char(32) NOT NULL,\r\n  `WarehouseTeamId` char(32) NOT NULL,\r\n  `OrderType` varchar(50) NOT NULL COMMENT '字典',\r\n  `OrderSource` varchar(50) NOT NULL COMMENT '同步、创建、导入',\r\n  `ProductNum` int NOT NULL,\r\n  `OrderTime` datetime NOT NULL,\r\n  `PaidTime` datetime NOT NULL,\r\n  `Currency` varchar(20) NOT NULL,\r\n  `Amount` decimal(18,8) NOT NULL,\r\n  `Discount` decimal(18,8) NOT NULL,\r\n  `LogisticeAmt` decimal(18,8) NOT NULL,\r\n  `OrderStatus` varchar(20) NOT NULL COMMENT '待审核、已审核、已完成',\r\n  `DeliveryStatus` varchar(20) NOT NULL COMMENT '待生成发货单、待发货、部分发货、发货完成',\r\n  `AbnormalStatus` varchar(20) NOT NULL COMMENT '正常、异常、部分异常',\r\n  `NeedQC` varchar(20) DEFAULT NULL COMMENT '需要、部分需要、不需要',\r\n  `QCPhotoStatus` varchar(20) DEFAULT NULL COMMENT '未上传、部分上传、已上传',\r\n  `QCStatus` varchar(20) DEFAULT NULL COMMENT '待确认、部分未通过、未通过、部分确认、已确认',\r\n  `CustomerRemark` varchar(1000) DEFAULT NULL,\r\n  `InnerRemark` varchar(1000) DEFAULT NULL,\r\n  `AddTime` datetime NOT NULL,\r\n  PRIMARY KEY (`SaleNo`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;");
                db.Ado.ExecuteCommand("INSERT INTO `t_order` VALUES ('100079334', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '0cadfa86573841979d4eb28900f302b2', '0b02d4b2cac248cda646b2a600f7ea33', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync',9, '2023-03-05 06:15:20', '2023-03-31 15:01:00', 'USD', 4051.00000000, -5.50000000, 25.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-20 15:02:38');\r\nINSERT INTO `t_order` VALUES ('100117530', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '5107edd336404e9c8daab28900f233b6', '9ee61277dc454910949bb29900f464e6', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2023-06-25 01:57:03', '2023-06-27 14:22:47', 'USD', 4051.00000000, 0.00000000, 30.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', 'w', '2025-03-07 14:49:49');\r\nINSERT INTO `t_order` VALUES ('2025030801', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '829030c03bd2459993b2b2a000a261f0', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-03-21 16:13:00', '2025-03-31 02:02:02', 'CNY', 4051.00000000, -1.00000000, 6.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'Need', 'Upload', 'Fail', '1', '1fdfdxcfd', '2025-03-28 11:10:26');\r\nINSERT INTO `t_order` VALUES ('2025040301', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-03 10:17:17', '2025-04-03 10:17:17', 'USD', 4051.00000000, -1.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'PartialNeed', 'Upload', 'WaitComfirm', '1', '1', '2025-04-03 10:18:53');\r\nINSERT INTO `t_order` VALUES ('400003882', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', '0cadfa86573841979d4eb28900f302b2', 'e26b32c5ce084857aa24b29500af47f1', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-04 19:54:00', '2022-01-04 20:00:06', 'USD', 4051.00000000, 0.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, 'WaitComfirm', '', '1724   1', '2025-03-07 14:40:36');\r\nINSERT INTO `t_order` VALUES ('400003884', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '4cedec0343aa4fceb1abb296010a00a3', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-05 11:23:00', '2022-01-10 16:52:14', 'USD', 4051.00000000, -38.00000000, 78.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 404DR26828052247608  513308908D834292B  1', '2025-03-07 14:40:41');\r\nINSERT INTO `t_order` VALUES ('400003885', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '6db02b4be89d405d8f01b296010ad93e', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-05 14:29:00', '2022-01-05 14:34:14', 'USD', 4051.00000000, -25.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '66C03866B5120823P  1', '2025-03-07 14:40:41');\r\nINSERT INTO `t_order` VALUES ('400003886', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '2c76f8a4f57b43df9997b296010ad9fa', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-05 14:36:00', '2022-01-05 14:42:33', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '0AR69289PE3275504 ', '2025-03-07 14:40:42');\r\nINSERT INTO `t_order` VALUES ('400003887', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'ce5e551824544546b3a3b296010adaa6', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-05 15:12:00', '2022-01-05 15:29:11', 'USD', 4051.00000000, -21.80000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1', '2025-03-07 14:40:42');\r\nINSERT INTO `t_order` VALUES ('400003888', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'ce5e551824544546b3a3b296010adaa6', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2021-12-31 15:25:00', '2022-01-05 15:38:14', 'USD', 4051.00000000, -21.80000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1', '2025-03-07 14:40:42');\r\nINSERT INTO `t_order` VALUES ('400003895', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '3ea0a58473c54f8cb667b296010ade0b', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2021-12-02 06:30:00', '2022-01-05 16:33:52', 'USD', 4051.00000000, -5.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-07 14:40:43');\r\nINSERT INTO `t_order` VALUES ('400003896', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '0c618e116c6f4630bc73b296010ade41', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2021-12-02 02:10:00', '2022-01-05 16:55:04', 'USD', 4051.00000000, -38.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-07 14:40:44');\r\nINSERT INTO `t_order` VALUES ('400003897', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '090273f5adc045a9a52cb296010adef4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2021-12-03 07:35:00', '2022-01-05 17:02:44', 'USD', 4051.00000000, -23.22000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-07 14:40:44');\r\nINSERT INTO `t_order` VALUES ('400003898', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '166570b664b3475ab14fb296010adf9a', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2021-12-02 06:05:00', '2022-01-05 17:10:16', 'USD', 4051.00000000, -21.42000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-07 14:40:44');\r\nINSERT INTO `t_order` VALUES ('400003905', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '0c618e116c6f4630bc73b296010ade41', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-08 13:48:00', '2022-01-08 13:54:40', 'USD', 4051.00000000, -20.00000000, 78.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '7LS82291RX492723T   1', '2025-03-07 14:40:44');\r\nINSERT INTO `t_order` VALUES ('400003906', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '0c618e116c6f4630bc73b296010ade41', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-08 14:02:00', '2022-01-08 14:04:42', 'USD', 4051.00000000, -33.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<span style=\\\"color: rgb(0, 0, 0); font-family: \\\" pingfang=\\\"\\\" sc\\\",=\\\"\\\" helvetica,=\\\"\\\" tahoma,=\\\"\\\" arial,=\\\"\\\" \\\"hiragino=\\\"\\\" sans=\\\"\\\" gb\\\",=\\\"\\\" \\\"microsoft=\\\"\\\" yahei\\\",=\\\"\\\" simsun,=\\\"\\\" heiti,=\\\"\\\" sans-serif;=\\\"\\\" font-size:=\\\"\\\" 12px;=\\\"\\\" font-weight:=\\\"\\\" 400;=\\\"\\\" white-space:=\\\"\\\" pre-wrap;\\\"=\\\"\\\"> 25769783C64395522  1<br><br/>', '2025-03-07 14:40:45');\r\nINSERT INTO `t_order` VALUES ('400003918', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'fb6b5f3aa5aa431bab35b296010ae193', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-14 11:01:00', '2022-01-14 11:05:15', 'USD', 4051.00000000, -11.99000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1835   6MY254698B392221A  1', '2025-03-07 14:40:45');\r\nINSERT INTO `t_order` VALUES ('400003919', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '41324ec2ed5446c9a536b296010ae24e', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-14 16:09:00', '2022-01-14 16:25:17', 'USD', 4051.00000000, -11.88000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<span style=\\\"color: rgb(0, 0, 0); font-family: \\\"PingFang SC\\\", Helvetica, Tahoma, Arial, \\\"Hiragino Sans GB\\\", \\\"Microsoft YaHei\\\", SimSun, Heiti, sans-serif; font-size: 12px; font-weight: 400; white-space: pre-wrap;\\\"> 3JA25320VV508043A 1<br/>', '2025-03-07 14:40:45');\r\nINSERT INTO `t_order` VALUES ('400003922', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'a9b67e07d3a74619b13fb296010ae312', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-17 14:47:00', '2022-01-17 14:54:11', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1864  1', '2025-03-07 14:40:45');\r\nINSERT INTO `t_order` VALUES ('400003923', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '16150f58d521449193f7b296010ae3e4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-14 11:20:00', '2022-01-17 15:28:07', 'USD', 4051.00000000, -27.28000000, 78.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '9E850041VS3701403​', '2025-03-07 14:40:46');\r\nINSERT INTO `t_order` VALUES ('400003929', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '5a86fb11b37042699596b296010ae4bc', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-19 13:59:00', '2022-01-19 14:29:08', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<span style=\\\"color: rgb(0, 0, 0); font-family: \\\" pingfang=\\\"\\\" sc\\\",=\\\"\\\" helvetica,=\\\"\\\" tahoma,=\\\"\\\" arial,=\\\"\\\" \\\"hiragino=\\\"\\\" sans=\\\"\\\" gb\\\",=\\\"\\\" \\\"microsoft=\\\"\\\" yahei\\\",=\\\"\\\" simsun,=\\\"\\\" heiti,=\\\"\\\" sans-serif;=\\\"\\\" font-size:=\\\"\\\" 12px;=\\\"\\\" font-weight:=\\\"\\\" 400;=\\\"\\\" white-space:=\\\"\\\" pre-wrap;\\\"=\\\"\\\"> 9D0825981D249242Y  1<br><br/>', '2025-03-07 14:40:46');\r\nINSERT INTO `t_order` VALUES ('400003936', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '166570b664b3475ab14fb296010adf9a', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-20 13:44:00', '2022-01-20 13:48:09', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<table data-type=\\\"sm-sheets\\\" data-row=\\\"46\\\" data-col=\\\"7\\\"><tbody><tr style=\\\"height: 22px;\\\"><td style=\\\"width: 136px; font-size: 9pt; white-space: nowrap;\\\" data-formatter=\\\"General\\\" data-value=\\\"1893\\\">1893</td></tr></tbody></table>1', '2025-03-07 14:40:46');\r\nINSERT INTO `t_order` VALUES ('400003937', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '5d8316e716a34049908bb296010ae592', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-20 16:22:00', '2022-01-20 16:30:12', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '8VV41390VN124632Y​  1', '2025-03-07 14:40:46');\r\nINSERT INTO `t_order` VALUES ('400003938', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'ebccd6f6ef18449b811eb296010ae5c4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-21 19:32:00', '2022-01-21 19:34:53', 'USD', 4051.00000000, -40.46000000, 78.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<span style=\\\"color: rgb(0, 0, 0); font-family: \\\" pingfang=\\\"\\\" sc\\\",=\\\"\\\" helvetica,=\\\"\\\" tahoma,=\\\"\\\" arial,=\\\"\\\" \\\"hiragino=\\\"\\\" sans=\\\"\\\" gb\\\",=\\\"\\\" \\\"microsoft=\\\"\\\" yahei\\\",=\\\"\\\" simsun,=\\\"\\\" heiti,=\\\"\\\" sans-serif;=\\\"\\\" font-size:=\\\"\\\" 12px;=\\\"\\\" font-weight:=\\\"\\\" 400;=\\\"\\\" white-space:=\\\"\\\" pre-wrap;\\\"=\\\"\\\">9E850041VS3701403  1<br><br/>', '2025-03-07 14:40:47');\r\nINSERT INTO `t_order` VALUES ('400003939', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'ebccd6f6ef18449b811eb296010ae5c4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-21 19:35:00', '2022-01-21 19:36:55', 'USD', 4051.00000000, -17.70000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '<span style=\\\"color: rgb(0, 0, 0); font-family: \\\" pingfang=\\\"\\\" sc\\\",=\\\"\\\" helvetica,=\\\"\\\" tahoma,=\\\"\\\" arial,=\\\"\\\" \\\"hiragino=\\\"\\\" sans=\\\"\\\" gb\\\",=\\\"\\\" \\\"microsoft=\\\"\\\" yahei\\\",=\\\"\\\" simsun,=\\\"\\\" heiti,=\\\"\\\" sans-serif;=\\\"\\\" font-size:=\\\"\\\" 12px;=\\\"\\\" font-weight:=\\\"\\\" 400;=\\\"\\\" white-space:=\\\"\\\" pre-wrap;\\\"=\\\"\\\"> 9D0825981D249242Y  1<br><br/>', '2025-03-07 14:40:47');\r\nINSERT INTO `t_order` VALUES ('400003946', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '727e63b242df47b8b610b296010ae8d5', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-24 11:24:00', '2022-01-24 11:29:14', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '5XF36741XK773310G\\n 1', '2025-03-07 14:40:47');\r\nINSERT INTO `t_order` VALUES ('400003949', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '7f4216c13564455693ceb296010ae9b4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-25 11:13:00', '2022-01-25 11:15:55', 'USD', 4051.00000000, -13.09000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2GF10488LY4106147  1', '2025-03-07 14:40:47');\r\nINSERT INTO `t_order` VALUES ('400003952', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '6db02b4be89d405d8f01b296010ad93e', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-26 10:27:00', '2022-01-26 10:40:37', 'USD', 4051.00000000, -29.00000000, 117.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 1X73926652093924R uk黑蓝是大巴黎  1', '2025-03-07 14:40:48');\r\nINSERT INTO `t_order` VALUES ('400003953', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '32affea294014a559b47b296010aed79', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-26 11:19:00', '2022-01-26 11:24:15', 'USD', 4051.00000000, -13.09000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 11A83446JR502224J  1', '2025-03-07 14:40:48');\r\nINSERT INTO `t_order` VALUES ('400003954', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '023ed7aa913c479692dab296010aedad', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-26 17:45:00', '2022-01-26 17:49:33', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '9AY73790TY233422G   回来加快物流  1', '2025-03-07 14:40:49');\r\nINSERT INTO `t_order` VALUES ('400003961', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '090273f5adc045a9a52cb296010adef4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-01-30 23:28:00', '2022-01-30 23:33:02', 'USD', 4051.00000000, -23.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2XE35706080267909   1\\n', '2025-03-07 14:40:49');\r\nINSERT INTO `t_order` VALUES ('400003979', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'bc4feb212668471f9ecdb296010aee9c', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-04 22:22:00', '2022-02-04 22:37:58', 'USD', 4051.00000000, -21.61000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '3UM91533N06535631  2.3号付款  1', '2025-03-07 14:40:49');\r\nINSERT INTO `t_order` VALUES ('400003983', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'bd74ef85b76947aaa860b296010aeed7', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-05 15:04:00', '2022-02-05 15:07:42', 'USD', 4051.00000000, -15.26000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 28Y202030J4074722  1', '2025-03-07 14:40:49');\r\nINSERT INTO `t_order` VALUES ('400003986', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'e068755e97dc4faeb744b296010aef08', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-07 11:27:00', '2022-02-07 11:32:19', 'USD', 4051.00000000, -18.06000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 06879823YN722644V  1\\n', '2025-03-07 14:40:50');\r\nINSERT INTO `t_order` VALUES ('400003987', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '1bddaabef89348fa8101b296010aef37', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-07 11:38:00', '2022-02-07 11:41:28', 'USD', 4051.00000000, -25.26000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 0TN096082B0853744​  1', '2025-03-07 14:40:50');\r\nINSERT INTO `t_order` VALUES ('400003990', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'ae771953fd754cf89fa3b296010af003', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-08 18:59:00', '2022-02-08 19:02:44', 'USD', 4051.00000000, -25.40000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 5L9578630G803294B  1', '2025-03-07 14:40:50');\r\nINSERT INTO `t_order` VALUES ('400003991', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '43fa7bde3b134464933bb296010af0c2', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-08 19:10:00', '2022-02-08 19:13:12', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '9PE01538JP1420507  1', '2025-03-07 14:40:50');\r\nINSERT INTO `t_order` VALUES ('400003993', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'da7e8aaebd404b3d9790b296010af0f1', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-09 11:10:00', '2022-02-09 13:54:35', 'USD', 4051.00000000, -75.00000000, 117.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '最后一双大巴黎，合并发货   8BC33482KB1909632  1', '2025-03-07 14:40:50');\r\nINSERT INTO `t_order` VALUES ('400003994', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '641bfd73dbf24af880d0b296010af28a', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-09 14:07:00', '2022-02-09 14:09:28', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 8XX952391K491901U  1', '2025-03-07 14:40:51');\r\nINSERT INTO `t_order` VALUES ('400003997', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'a90d2a0ca0b844659ad2b296010af2c6', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-10 14:04:00', '2022-02-10 14:06:14', 'USD', 4051.00000000, -15.15000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 14U01816WC954373K  1', '2025-03-07 14:40:51');\r\nINSERT INTO `t_order` VALUES ('400004002', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '2bd357652ed74054b68db296010af365', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-11 14:04:00', '2022-02-11 14:11:13', 'USD', 4051.00000000, -18.06000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2062 1', '2025-03-07 14:40:52');\r\nINSERT INTO `t_order` VALUES ('400004004', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, 'b67ca802e764452f8abfb296010af415', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-11 14:53:00', '2022-02-11 14:56:58', 'USD', 4051.00000000, -18.06000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1', '2025-03-07 14:40:52');\r\nINSERT INTO `t_order` VALUES ('400004005', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '814a95a228ad4a8da2b6b296010af4c4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-11 15:35:00', '2022-02-11 15:42:27', 'USD', 4051.00000000, -21.93000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '待确认', '2025-03-07 14:40:52');\r\nINSERT INTO `t_order` VALUES ('400004008', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '3ea0a58473c54f8cb667b296010ade0b', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-11 18:27:00', '2022-02-11 18:30:58', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 121458994W741784R  1', '2025-03-07 14:40:52');\r\nINSERT INTO `t_order` VALUES ('400004017', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', '0cadfa86573841979d4eb28900f302b2', '403374500e7a4a54b267b2990098fa4b', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-15 11:51:00', '2022-02-15 11:57:21', 'USD', 4051.00000000, -23.44000000, 39.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 1BL2449016438791J  1', '2025-03-07 14:40:53');\r\nINSERT INTO `t_order` VALUES ('400004020', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '1c20d23a069c46cf9e7db2990098fa8e', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-16 12:02:00', '2022-02-16 12:05:38', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', ' 8AH05237KA606360F  1', '2025-03-07 14:40:53');\r\nINSERT INTO `t_order` VALUES ('400004025', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '42f781f58d474603a1bbb2990098fb40', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-16 16:20:00', '2022-02-16 16:26:35', 'USD', 4051.00000000, -23.33000000, 39.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '1', '2025-03-07 14:40:53');\r\nINSERT INTO `t_order` VALUES ('400004034', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', '0cadfa86573841979d4eb28900f302b2', 'f2f3d53e8c7c49b19e7bb2990098fbda', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-19 09:30:00', '2022-02-19 09:33:44', 'USD', 4051.00000000, -37.52000000, 78.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2XR283076E822462U  1', '2025-03-07 14:40:53');\r\nINSERT INTO `t_order` VALUES ('400004035', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '5ab5fa039f544c8fb9bcb2990098fd49', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-19 10:50:00', '2022-02-19 10:54:26', 'USD', 4051.00000000, -46.00000000, 78.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2134 1', '2025-03-07 14:40:54');\r\nINSERT INTO `t_order` VALUES ('400004037', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '7a222b3d2811412da2e0b2990098ffe2', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-19 18:20:00', '2022-02-19 18:28:33', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '2116  $125.78  1', '2025-03-07 14:40:54');\r\nINSERT INTO `t_order` VALUES ('400004046', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '9419f60f2dd940a1bfb3b29900990099', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-24 10:05:00', '2022-02-24 10:25:57', 'USD', 4051.00000000, -26.00000000, 78.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '', '2025-03-07 14:40:55');\r\nINSERT INTO `t_order` VALUES ('400004050', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', NULL, '16150f58d521449193f7b296010ae3e4', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Sync', 9, '2022-02-25 14:15:00', '2022-02-25 14:18:27', 'USD', 4051.00000000, -15.00000000, 39.00000000, 'Audited', 'PartCreateInvoice', 'Normal', NULL, NULL, NULL, '', '44L6891437977440E', '2025-03-07 14:40:55');\r\nINSERT INTO `t_order` VALUES ('494399465843824', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-08 10:24:49', '2025-04-08 10:24:49', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'Need', 'Upload', 'Comfirm', NULL, NULL, '2025-04-08 10:26:18');\r\nINSERT INTO `t_order` VALUES ('494415779158875', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-08 14:50:27', '2025-04-08 14:50:27', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'Need', 'Upload', 'Comfirm', NULL, NULL, '2025-04-08 14:51:49');\r\nINSERT INTO `t_order` VALUES ('494679736289570', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-11 14:26:23', '2025-04-11 14:26:23', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'PartialNeed', 'PartialUpload', 'PartialComfirm', '1', '1', '2025-04-11 14:28:00');\r\nINSERT INTO `t_order` VALUES ('494934543151959', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-14 11:34:12', '2025-04-14 11:34:12', 'CNY', 4051.00000000, 0.00000000, 2.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'Need', 'PartialUpload', 'WaitComfirm', '1', '1', '2025-04-14 11:35:15');\r\nINSERT INTO `t_order` VALUES ('495310425046098', '88beaf408e904862ba3fb28200a44b16', '083d67fb248944eeaf14b28900f9627b', '0cadfa86573841979d4eb28900f302b2', 'e26b32c5ce084857aa24b29500af47f1', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-18 17:31:53', '2025-04-18 17:31:53', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'NotNeed', NULL, NULL, NULL, NULL, '2025-04-18 17:33:07');\r\nINSERT INTO `t_order` VALUES ('496256453332987', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '0cadfa86573841979d4eb28900f302b2', '2ad773ce6ecc4567b86eb28e00b2efbd', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-29 10:09:47', '2025-04-29 10:09:47', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', 'NotNeed', NULL, NULL, NULL, NULL, '2025-04-29 10:10:43');\r\nINSERT INTO `t_order` VALUES ('496256796790115', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '0cadfa86573841979d4eb28900f302b2', '2ad773ce6ecc4567b86eb28e00b2efbd', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-04-29 10:12:42', '2025-04-29 10:12:42', 'CNY', 4051.00000000, 0.00000000, 2.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', 'NotNeed', NULL, NULL, '1', '1', '2025-04-29 10:16:18');\r\nINSERT INTO `t_order` VALUES ('497157089599262', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '0cadfa86573841979d4eb28900f302b2', '2ad773ce6ecc4567b86eb28e00b2efbd', '520fa3c3c0a74d81ba11b283009e47b5', 'Celebrity', 'Create', 9, '2025-05-09 14:28:19', '2025-05-09 14:28:19', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'Need', 'PartialUpload', 'PartialComfirm', NULL, NULL, '2025-05-09 14:29:30');\r\nINSERT INTO `t_order` VALUES ('497169100776340', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-05-09 03:33:22', '2025-05-09 17:42:55', 'USD', 4051.00000000, 0.00000000, 1.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', 'NotNeed', NULL, NULL, '1', '1', '2025-05-09 17:45:00');\r\nINSERT INTO `t_order` VALUES ('497169408607770', '88beaf408e904862ba3fb28200a44b16', '3e18cacfdca34ee293e4b28900f61d6a', '0cadfa86573841979d4eb28900f302b2', '4b91393718f3428fbd8db2ae01045173', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-05-09 11:24:01', '2025-05-09 14:22:01', 'CNY', 4051.00000000, 0.00000000, 0.00000000, 'WaitAudit', 'PartCreateInvoice', 'Normal', 'Need', 'NotUpload', NULL, '1', '1', '2025-05-09 17:50:01');\r\nINSERT INTO `t_order` VALUES ('497169649254595', '88beaf408e904862ba3fb28200a44b16', '66ac533b7983402b8673b28900fafda9', '0cadfa86573841979d4eb28900f302b2', '2ad773ce6ecc4567b86eb28e00b2efbd', '520fa3c3c0a74d81ba11b283009e47b5', 'Sale', 'Create', 9, '2025-05-09 17:53:02', '2025-05-09 17:53:02', 'CNY', 4051.00000000, 0.00000000, 1.00000000, 'Audited', 'PartCreateInvoice', 'Normal', 'NotNeed', NULL, NULL, NULL, NULL, '2025-05-09 17:53:56');");
                db.Ado.ExecuteCommand("CREATE TABLE `t_orderamt` (\r\n  `SaleNo` varchar(50) NOT NULL,\r\n  `Type` varchar(20) NOT NULL COMMENT '订单金额、订单售后',\r\n  `AbMoneyNo` varchar(50) DEFAULT NULL COMMENT '异常款项单号',\r\n  `ServiceNo` varchar(50) DEFAULT NULL COMMENT '类型为“订单售后”时必填',\r\n  `PaymentMethod` varchar(50) DEFAULT NULL COMMENT '字典Key',\r\n  `PaymentCurrency` varchar(20) DEFAULT NULL,\r\n  `PaymentAmt` decimal(18,8) DEFAULT NULL,\r\n  `PaymentNo` varchar(50) DEFAULT NULL,\r\n  `PaymentRemark` varchar(1000) DEFAULT NULL,\r\n  `AddTime` datetime NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;");
                db.Ado.ExecuteCommand("INSERT INTO `t_orderamt` VALUES ('400003882', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 148.00000000, '', NULL, '2025-03-07 14:40:37');\r\nINSERT INTO `t_orderamt` VALUES ('400003884', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 298.00000000, '', NULL, '2025-03-07 14:40:41');\r\nINSERT INTO `t_orderamt` VALUES ('400003885', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 123.00000000, '', NULL, '2025-03-07 14:40:42');\r\nINSERT INTO `t_orderamt` VALUES ('400003886', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 143.00000000, '', NULL, '2025-03-07 14:40:42');\r\nINSERT INTO `t_orderamt` VALUES ('400003887', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 126.20000000, '', NULL, '2025-03-07 14:40:42');\r\nINSERT INTO `t_orderamt` VALUES ('400003888', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 126.20000000, '', NULL, '2025-03-07 14:40:42');\r\nINSERT INTO `t_orderamt` VALUES ('400003895', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 143.00000000, '', NULL, '2025-03-07 14:40:44');\r\nINSERT INTO `t_orderamt` VALUES ('400003896', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 140.00000000, '', NULL, '2025-03-07 14:40:44');\r\nINSERT INTO `t_orderamt` VALUES ('400003897', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 144.78000000, '', NULL, '2025-03-07 14:40:44');\r\nINSERT INTO `t_orderamt` VALUES ('400003898', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 136.58000000, '', NULL, '2025-03-07 14:40:44');\r\nINSERT INTO `t_orderamt` VALUES ('400003905', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 196.00000000, '', NULL, '2025-03-07 14:40:45');\r\nINSERT INTO `t_orderamt` VALUES ('400003906', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 135.00000000, '', NULL, '2025-03-07 14:40:45');\r\nINSERT INTO `t_orderamt` VALUES ('400003918', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 136.01000000, '', NULL, '2025-03-07 14:40:45');\r\nINSERT INTO `t_orderamt` VALUES ('400003919', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 135.12000000, '', NULL, '2025-03-07 14:40:45');\r\nINSERT INTO `t_orderamt` VALUES ('400003922', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 153.00000000, '', NULL, '2025-03-07 14:40:46');\r\nINSERT INTO `t_orderamt` VALUES ('400003923', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 298.72000000, '', NULL, '2025-03-07 14:40:46');\r\nINSERT INTO `t_orderamt` VALUES ('400003929', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 153.00000000, '', NULL, '2025-03-07 14:40:46');\r\nINSERT INTO `t_orderamt` VALUES ('400003936', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:46');\r\nINSERT INTO `t_orderamt` VALUES ('400003937', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 143.00000000, '', NULL, '2025-03-07 14:40:47');\r\nINSERT INTO `t_orderamt` VALUES ('400003938', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 275.54000000, '', NULL, '2025-03-07 14:40:47');\r\nINSERT INTO `t_orderamt` VALUES ('400003939', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 139.30000000, '', NULL, '2025-03-07 14:40:47');\r\nINSERT INTO `t_orderamt` VALUES ('400003946', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 162.00000000, '', NULL, '2025-03-07 14:40:47');\r\nINSERT INTO `t_orderamt` VALUES ('400003949', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 144.91000000, '', NULL, '2025-03-07 14:40:48');\r\nINSERT INTO `t_orderamt` VALUES ('400003952', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 444.00000000, '', NULL, '2025-03-07 14:40:48');\r\nINSERT INTO `t_orderamt` VALUES ('400003953', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 144.91000000, '', NULL, '2025-03-07 14:40:49');\r\nINSERT INTO `t_orderamt` VALUES ('400003954', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:49');\r\nINSERT INTO `t_orderamt` VALUES ('400003961', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 145.00000000, '', NULL, '2025-03-07 14:40:49');\r\nINSERT INTO `t_orderamt` VALUES ('400003979', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 126.39000000, '', NULL, '2025-03-07 14:40:49');\r\nINSERT INTO `t_orderamt` VALUES ('400003983', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 132.74000000, '', NULL, '2025-03-07 14:40:50');\r\nINSERT INTO `t_orderamt` VALUES ('400003986', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 149.94000000, '', NULL, '2025-03-07 14:40:50');\r\nINSERT INTO `t_orderamt` VALUES ('400003987', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 132.74000000, '', NULL, '2025-03-07 14:40:50');\r\nINSERT INTO `t_orderamt` VALUES ('400003990', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 152.60000000, '', NULL, '2025-03-07 14:40:50');\r\nINSERT INTO `t_orderamt` VALUES ('400003991', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:50');\r\nINSERT INTO `t_orderamt` VALUES ('400003993', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 318.00000000, '', NULL, '2025-03-07 14:40:51');\r\nINSERT INTO `t_orderamt` VALUES ('400003994', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:51');\r\nINSERT INTO `t_orderamt` VALUES ('400003997', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 132.85000000, '', NULL, '2025-03-07 14:40:52');\r\nINSERT INTO `t_orderamt` VALUES ('400004002', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 149.94000000, '', NULL, '2025-03-07 14:40:52');\r\nINSERT INTO `t_orderamt` VALUES ('400004004', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 149.94000000, '', NULL, '2025-03-07 14:40:52');\r\nINSERT INTO `t_orderamt` VALUES ('400004005', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 146.07000000, '', NULL, '2025-03-07 14:40:52');\r\nINSERT INTO `t_orderamt` VALUES ('400004008', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:53');\r\nINSERT INTO `t_orderamt` VALUES ('400004017', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 124.57000000, '', NULL, '2025-03-07 14:40:53');\r\nINSERT INTO `t_orderamt` VALUES ('400004020', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 133.00000000, '', NULL, '2025-03-07 14:40:53');\r\nINSERT INTO `t_orderamt` VALUES ('400004025', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 124.67000000, '', NULL, '2025-03-07 14:40:53');\r\nINSERT INTO `t_orderamt` VALUES ('400004034', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 308.48000000, '', NULL, '2025-03-07 14:40:54');\r\nINSERT INTO `t_orderamt` VALUES ('400004035', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 290.00000000, '', NULL, '2025-03-07 14:40:54');\r\nINSERT INTO `t_orderamt` VALUES ('400004037', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 143.00000000, '', NULL, '2025-03-07 14:40:55');\r\nINSERT INTO `t_orderamt` VALUES ('400004046', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 300.00000000, '', NULL, '2025-03-07 14:40:55');\r\nINSERT INTO `t_orderamt` VALUES ('400004050', 'OrderAmount', NULL, NULL, 'a036609dea1c444aa8e9b29500aefff0', 'USD', 123.00000000, '', NULL, '2025-03-07 14:40:55');\r\nINSERT INTO `t_orderamt` VALUES ('100117530', 'OrderAmount', NULL, NULL, '15ec74d09e55456f8268b29900f45f9f', 'USD', 145.00000000, '1111', NULL, '2025-03-07 14:49:49');\r\nINSERT INTO `t_orderamt` VALUES ('400003882', 'OrderService', '013759b0d19442979b8085180e0f5b11', '400003882', '15ec74d09e55456f8268b29900f45f9f', 'USD', 123.00000000, '3653', '售后退款', '2025-03-08 10:38:53');\r\nINSERT INTO `t_orderamt` VALUES ('100079334', 'OrderAmount', NULL, NULL, '8aed0b8d96e443439d6eb292010a9097', 'USD', 74.50000000, '20230305061850870837', NULL, '2025-03-20 15:02:38');\r\nINSERT INTO `t_orderamt` VALUES ('2025030801', 'OrderAmount', NULL, NULL, '8aed0b8d96e443439d6eb292010a9097', 'USD', 6.00000000, '1', '1', '2025-03-28 11:10:26');\r\nINSERT INTO `t_orderamt` VALUES ('2025040301', 'OrderAmount', NULL, NULL, '8aed0b8d96e443439d6eb292010a9097', 'CNY', 2.00000000, '1', '1', '2025-04-03 10:18:53');\r\nINSERT INTO `t_orderamt` VALUES ('494399465843824', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-08 10:26:18');\r\nINSERT INTO `t_orderamt` VALUES ('494415779158875', 'OrderAmount', NULL, NULL, '8aed0b8d96e443439d6eb292010a9097', 'CNY', 1.00000000, '1', NULL, '2025-04-08 14:51:49');\r\nINSERT INTO `t_orderamt` VALUES ('494679736289570', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-11 14:28:00');\r\nINSERT INTO `t_orderamt` VALUES ('494934543151959', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-14 11:35:15');\r\nINSERT INTO `t_orderamt` VALUES ('495310425046098', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-18 17:33:07');\r\nINSERT INTO `t_orderamt` VALUES ('495310425046098', 'OrderService', '495920219856070', '495920219856828', '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-25 17:28:58');\r\nINSERT INTO `t_orderamt` VALUES ('495310425046098', 'OrderService', '495931959013376', '495920219856828', 'a036609dea1c444aa8e9b29500aefff0', 'CNY', 7.00000000, '7', NULL, '2025-04-25 18:09:14');\r\nINSERT INTO `t_orderamt` VALUES ('494679736289570', 'OrderService', '495932249751711', '495932249752482', '7c187fdc1043424ab943b29500af3323', 'CNY', 5.00000000, '5', NULL, '2025-04-25 18:13:58');\r\nINSERT INTO `t_orderamt` VALUES ('494679736289570', 'OrderService', '495932413625683', '495932413624673', '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-04-25 18:16:38');\r\nINSERT INTO `t_orderamt` VALUES ('494679736289570', 'OrderService', '495932993944451', '495932993945403', 'a132d1d8c2f44ffd99e2b2890116b13d', 'CNY', 3.00000000, '3', NULL, '2025-04-25 18:26:04');\r\nINSERT INTO `t_orderamt` VALUES ('496256453332987', 'OrderAmount', NULL, NULL, NULL, NULL, 0.00000000, NULL, NULL, '2025-04-29 10:10:43');\r\nINSERT INTO `t_orderamt` VALUES ('496256796790115', 'OrderAmount', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-04-29 10:16:18');\r\nINSERT INTO `t_orderamt` VALUES ('497157089599262', 'OrderAmount', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-09 14:29:30');\r\nINSERT INTO `t_orderamt` VALUES ('497169100776340', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-05-09 17:45:00');\r\nINSERT INTO `t_orderamt` VALUES ('497169408607770', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', '1', '2025-05-09 17:50:01');\r\nINSERT INTO `t_orderamt` VALUES ('497169649254595', 'OrderAmount', NULL, NULL, '7c187fdc1043424ab943b29500af3323', 'CNY', 1.00000000, '1', NULL, '2025-05-09 17:53:56');");
                db.Ado.ExecuteCommand("CREATE TABLE `t_orderproduct` (\r\n  `OrderProductId` char(32) NOT NULL,\r\n  `SaleNo` varchar(50) NOT NULL,\r\n  `Name` varchar(500) NOT NULL COMMENT '商城订单同步',\r\n  `BatchName` varchar(100) DEFAULT NULL COMMENT '供应商品名称',\r\n  `ImagePath` varchar(600) DEFAULT NULL,\r\n  `Specifications` varchar(200) NOT NULL COMMENT '商城订单同步',\r\n  `Color` varchar(200) DEFAULT NULL,\r\n  `Size` varchar(50) DEFAULT NULL COMMENT '供应商品尺码',\r\n  `Source` varchar(50) DEFAULT NULL COMMENT '自供、调货',\r\n  `ProductType` varchar(50) NOT NULL COMMENT '商品、赠品',\r\n  `Category` varchar(50) DEFAULT NULL COMMENT '字典Key',\r\n  `SpecialRequire` varchar(100) DEFAULT NULL,\r\n  `NeedQC` bit(1) NOT NULL,\r\n  `QCStatus` varchar(20) DEFAULT NULL,\r\n  `TakePhotoTime` datetime DEFAULT NULL,\r\n  `QCTime` datetime DEFAULT NULL,\r\n  `ProductPrice` decimal(18,8) NOT NULL,\r\n  `PurchasePrice` decimal(18,8) NOT NULL,\r\n  `ProductNum` int NOT NULL,\r\n  `DeliveryNum` int NOT NULL,\r\n  `CancelDeliveryNum` int NOT NULL,\r\n  `ServiceNum` int NOT NULL,\r\n  `HasQCService` bit(1) DEFAULT NULL COMMENT '质检不通过后，是否已经发起售后单据',\r\n  `Remark` varchar(1000) DEFAULT NULL,\r\n  `ExtOrderProId` varchar(20) DEFAULT NULL,\r\n  `Sequence` int NOT NULL COMMENT '序号',\r\n  PRIMARY KEY (`OrderProductId`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;");
                db.Ado.ExecuteCommand("INSERT INTO `t_orderproduct` VALUES ('02e50b35ad964011bc3ab2ce00a7bcad', '496256453332987', 'x', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/369bbc34103f4ac9bb19b2ce00a7b5ff.jpg', 'x', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 6.00000000, 450.00000000, 1, 0, 0, 0, NULL, NULL, NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('134d74cdd7534865ace0b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 9);\r\nINSERT INTO `t_orderproduct` VALUES ('254e99dcb2e14c9db874b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('2923cd484b5f46459350b2c301213f3a', '495310425046098', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-18/bdbad0346ae64a90a961b2c301213d57.png', '1', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'0', NULL, NULL, NULL, 1.00000000, 450.00000000, 1, 0, 1, 1, NULL, '1', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('2acb8c59186945b89d1bb2b900f4f243', '494415779158875', '商品1', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'1', 'Comfirm', '2025-04-09 11:31:21', '2025-04-09 11:47:11', 3.00000000, 0.63000000, 1, 1, 0, 0, NULL, NULL, NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('3110cff1d6994321b6e3b2bc00ee673a', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'Fail', '2025-04-11 15:03:02', '2025-04-11 15:03:21', 3.00000000, 0.63000000, 1, 0, 0, 1, b'0', NULL, NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('36e04570695444479f73b2ca012fcac9', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 3.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 7);\r\nINSERT INTO `t_orderproduct` VALUES ('3d88b9ea2cad4b83b30db2b900f4f243', '494415779158875', '商品1', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'1', 'Comfirm', '2025-04-08 15:04:42', '2025-04-09 11:03:48', 1.00000000, 1.00000000, 1, 1, 0, 0, NULL, NULL, NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('529c096980884d69b6f4b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 5);\r\nINSERT INTO `t_orderproduct` VALUES ('5fdf8194b55f4e218f74b2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-08 15:59:49', '2025-04-09 11:23:33', 6.00000000, 0.63000000, 1, 1, 0, 0, NULL, NULL, NULL, 4);\r\nINSERT INTO `t_orderproduct` VALUES ('63047c20678d40c8a19fb2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 8);\r\nINSERT INTO `t_orderproduct` VALUES ('69c29dd35aa946b6ba28b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 6);\r\nINSERT INTO `t_orderproduct` VALUES ('6a16a75527554305abc3b2ce00a945bc', '496256796790115', 'ds', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/bfdfdf0ca8a948c7a716b2ce00a94436.jpg', 'ds', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'0', NULL, NULL, NULL, 3.00000000, 450.00000000, 1, 0, 0, 0, NULL, '3', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('6d6a3f2f32e4416c8062b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 4);\r\nINSERT INTO `t_orderproduct` VALUES ('6da8eec4b31d4294afb9b2d80125e314', '497169408607770', 'fd', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d17349d253604fa1bf75b2d80125deb1.jpg', 'fd', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 1.00000000, 450.00000000, 1, 0, 0, 0, NULL, '1', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('6e01a57c6b94459d959ab2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-09 14:24:27', '2025-04-09 14:34:46', 6.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 8);\r\nINSERT INTO `t_orderproduct` VALUES ('75f8ef473d7747f6abfcb2b400a9fb98', '2025040301', '商品2', '商品2', 'ERP1/OrderProduct/2025-04-03/75d004b47c3146489e95b2b400a9dd89.png', '1', '蓝色', '1', 'TransferGoods', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'0', NULL, NULL, NULL, 1.00000000, 1.00000000, 1, 0, 0, 0, NULL, '1', NULL, 0);\r\nINSERT INTO `t_orderproduct` VALUES ('77a9f708274b430b8d8db2d80126f67a', '497169649254595', '修改商品', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/76d6745a49b2436c99dfb2d80126f47d.jpg', '1', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 1.00000000, 450.00000000, 1, 0, 0, 0, NULL, NULL, NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('7e4b813dc999404f877cb2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-09 14:23:05', '2025-04-09 14:35:24', 6.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 7);\r\nINSERT INTO `t_orderproduct` VALUES ('84f7918b34fe489ba62fb2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-09 14:34:33', '2025-04-09 14:36:42', 6.00000000, 0.63000000, 1, 1, 0, 0, NULL, NULL, NULL, 9);\r\nINSERT INTO `t_orderproduct` VALUES ('8623a46b43b549ea971ab2b400a9fb98', '2025040301', '商品1', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-03/9f0d819ca3d94ebe9a30b2b400a9c79c.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'WaitComfirm', '2025-04-08 10:00:20', NULL, 6.00000000, 0.63000000, 1, 0, 0, 0, NULL, '1', NULL, 0);\r\nINSERT INTO `t_orderproduct` VALUES ('8ae4c57b862640f6bd73b2ca012c7720', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 3.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 5);\r\nINSERT INTO `t_orderproduct` VALUES ('9038c22dfb6e4863ba50b2ca00f6b000', '495310425046098', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-18/bdbad0346ae64a90a961b2c301213d57.png', '1', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'0', NULL, NULL, NULL, 1.00000000, 450.00000000, 1, 0, 0, 0, NULL, '1', NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('94f51fdeeb574fc391b6b2bc00ee673a', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'Comfirm', '2025-04-11 15:03:10', '2025-04-11 15:03:23', 3.00000000, 0.63000000, 1, 1, 0, 1, NULL, NULL, NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('9b67c12a98424ac09152b2ca012d32aa', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 3.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 6);\r\nINSERT INTO `t_orderproduct` VALUES ('9c6aad1281da4bf28a2cb2bc00ee673a', '494679736289570', '衣服', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-03/75d004b47c3146489e95b2b400a9dd89.png', '12', '013759b0d19442979b8085180e0f5b43', '013759b0d19442979b8085180e022b43', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 2.00000000, 0.23000000, 1, 1, 0, 1, NULL, NULL, NULL, 4);\r\nINSERT INTO `t_orderproduct` VALUES ('a11adc9dcd0948158de0b29900f1dd61', '400003882', 'Dope sneakers Adidas Yeezy Slide Reps Onyx HQ6448 ', '产品批次名称', 'ERP1/Product/2025-03-20/a7a832806c0649538554b2a600f7ea72.jpg', 'US12/UK12/EUR47/CM29.5', '颜色', '尺码', 'TransferGoods', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '特殊需求', b'1', 'WaitComfirm', '2025-03-20 15:21:23', '2025-03-20 15:21:27', 55.00000000, 1.30000000, 1, 0, 0, 0, NULL, NULL, NULL, 0);\r\nINSERT INTO `t_orderproduct` VALUES ('a12045686cc243119eddb2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-09 13:57:13', '2025-04-09 14:35:34', 6.00000000, 0.63000000, 1, 0, 0, 0, NULL, NULL, NULL, 6);\r\nINSERT INTO `t_orderproduct` VALUES ('a87e43acb38f45869120b2bf00bef488', '494934543151959', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'WaitComfirm', '2025-04-14 11:53:51', NULL, 1.00000000, 0.63000000, 1, 0, 0, 0, NULL, '1', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('a88436e4489b499b973ab2ce00a7bcad', '496256453332987', 'x', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/369bbc34103f4ac9bb19b2ce00a7b5ff.jpg', 'x', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 6.00000000, 450.00000000, 1, 0, 0, 0, NULL, NULL, NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('b1ab5cc74b9d4e70a24fb2d8012482cb', '497169100776340', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/fffde927e1694313ab48b2d801243907.jpg', '1', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'0', NULL, NULL, NULL, 1.00000000, 450.00000000, 1, 0, 0, 0, NULL, '1', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('b92532e0b0fe49b78e78b2ce00f0f172', '494679736289570', '鞋子', '1', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '1', '1', 'TransferGoods', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 31.00000000, 1.00000000, 1, 0, 0, 0, NULL, NULL, NULL, 9);\r\nINSERT INTO `t_orderproduct` VALUES ('b9a42ef685dc4b029f3db2bf00bef488', '494934543151959', '衣服', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 1.00000000, 0.63000000, 1, 0, 0, 0, NULL, '1', NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('bc7ea2f6b4c7468c80e4b2b900f4f243', '494415779158875', '商品1', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'1', 'Fail', '2025-04-08 15:07:01', '2025-04-09 11:04:41', 3.00000000, 0.63000000, 1, 0, 0, 0, b'0', NULL, NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('be159816dff346269558b2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', 'Comfirm', '2025-05-09 14:40:34', '2025-05-09 14:40:52', 450.00000000, 450.00000000, 1, 1, 0, 0, NULL, '09', NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('c6c41a0743d4448c934bb2bf00bef488', '494934543151959', '衣服', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', NULL, NULL, NULL, 1.00000000, 0.63000000, 1, 0, 0, 0, NULL, '1', NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('ca51b0be3df0493eb1bdb2ae00b823c8', '2025030801', '订单商品1', '1', 'ERP1/OrderProduct/2025-04-03/bd6b14fb1dfc4046ae2bb2b40098f682.png', '尺码1', '1', '1', 'TransferGoods', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '161', b'1', 'WaitComfirm', NULL, NULL, 81.00000000, 1.00000000, 1, 0, 0, 0, NULL, '91dsssssssssssssssssszxxxxxxxxxxxxxxxxxxx的萨瓦阿斯顿噶噶熬过去阿卡阿卡拉齐奥人咖啡暌违爱国v夸张啦的撒热i情况噶快公开v子女啊看直播空间卡了就去安徽那块女子空军卡了爱克发然后就氟苯尼考咋', NULL, 0);\r\nINSERT INTO `t_orderproduct` VALUES ('cade8c00a444446f9a1bb2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', 'Comfirm', '2025-05-09 14:40:34', '2025-05-09 14:40:52', 450.00000000, 450.00000000, 1, 0, 1, 1, NULL, '09', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('d033de632b5f4c2083b3b2ca0130a7a2', '494679736289570', '衣服', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-03/75d004b47c3146489e95b2b400a9dd89.png', '12', '013759b0d19442979b8085180e0f5b43', '013759b0d19442979b8085180e022b43', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 2.00000000, 0.23000000, 1, 0, 0, 0, NULL, NULL, NULL, 8);\r\nINSERT INTO `t_orderproduct` VALUES ('d3edbca2e8974f869293b2ce00a7bcad', '496256453332987', 'x', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/369bbc34103f4ac9bb19b2ce00a7b5ff.jpg', 'x', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', NULL, b'0', NULL, NULL, NULL, 6.00000000, 450.00000000, 1, 0, 0, 0, NULL, NULL, NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('d92d196a9cbf46bfb0d3b2ce00a945bc', '496256796790115', 'ds', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/bfdfdf0ca8a948c7a716b2ce00a94436.jpg', 'ds', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'0', NULL, NULL, NULL, 3.00000000, 450.00000000, 1, 0, 0, 0, NULL, '3', NULL, 2);\r\nINSERT INTO `t_orderproduct` VALUES ('d9f3b87ece7c4c8a8b46b2b900ac0526', '494399465843824', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/e0f05f79daa74c93ae5ab2b900abcc99.png', '12', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'Comfirm', '2025-04-08 12:01:14', '2025-04-09 14:45:46', 1.00000000, 0.63000000, 1, 0, 0, 0, NULL, '1', NULL, 1);\r\nINSERT INTO `t_orderproduct` VALUES ('e03495fd9c1242d98e2bb2d800eed117', '497157089599262', '鞋子', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-05-09/d6b857684a5d49ef9138b2d800eecf12.jpg', '156', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '09', b'1', NULL, NULL, NULL, 450.00000000, 450.00000000, 1, 0, 0, 0, NULL, '09', NULL, 7);\r\nINSERT INTO `t_orderproduct` VALUES ('ee623b07f9e7470483ffb2b900f4f243', '494415779158875', '商品2', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/9141ab51fb6944dba329b2b900f4c32c.png', '2', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Gift', 'd15a116e8f754d46a6a9b2a000fbc90b', '6', b'1', 'Comfirm', '2025-04-09 11:55:25', '2025-04-09 13:56:12', 6.00000000, 0.63000000, 1, 1, 0, 0, NULL, NULL, NULL, 5);\r\nINSERT INTO `t_orderproduct` VALUES ('f5f6c56b69ac44e9b52db2ce00a945bc', '496256796790115', 'ds', '2a1a97424a7c497eab38b2c200ba6dab', 'ERP1/OrderProduct/2025-04-29/bfdfdf0ca8a948c7a716b2ce00a94436.jpg', 'ds', '118d4792d3e84ac792b3b2c200ba6dac', '12263edbe24449238323b2c200ba6dac', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '3', b'0', NULL, NULL, NULL, 3.00000000, 450.00000000, 1, 0, 0, 0, NULL, '3', NULL, 3);\r\nINSERT INTO `t_orderproduct` VALUES ('f6cccaa1194445209aceb2bc00ee6739', '494679736289570', '鞋子', '013759b0d19442979b8085180e0f5b4a', 'ERP1/OrderProduct/2025-04-08/dec7dc5eba18404e8c48b2b900f4c076.png', '1', '013759b0d19442979b8085180e0f5b41', '013759b0d19442979b808518090f5b41', 'Confess', 'Product', 'd15a116e8f754d46a6a9b2a000fbc90b', '1', b'1', 'Comfirm', '2025-04-11 14:35:15', '2025-04-11 14:59:39', 3.00000000, 0.63000000, 1, 1, 0, 1, NULL, NULL, NULL, 1);");

            }

            db.Aop.OnError = (exp) =>
            {
                string message = $"{exp.Message}{Environment.NewLine}{exp.Sql}{Environment.NewLine}";
                if (exp.Parametres == null)
                {
                    message += "{}";
                }
                else
                {
                    var pars = exp.Parametres as SugarParameter[];
                    message += db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value));
                }
            }; 

            var query = db.Queryable<OrderEntity>()
                .InnerJoin<OrderAmtEntity>((order, orderAmt) => orderAmt.SaleNo == order.SaleNo && orderAmt.Type == "OrderAmount")
                ;
            query.OrderByDescending((order) => order.AddTime);
            query.Includes((order) => order.OrderProductEntities.Select((orderProduct) => new OrderProductEntity() { ProductNum = orderProduct.ProductNum, PurchasePrice = orderProduct.PurchasePrice }).ToList());

            var queryN = query.Select((order, orderAmt) => new OrderEntity()
            {
                SaleNo = order.SaleNo,
                BusinessTeamId = order.BusinessTeamId,
                WebsiteId = order.WebsiteId,
                BusinesserId = order.BusinesserId,
                CustomerId = order.CustomerId,
                ProductNum = order.ProductNum,
                Amount = order.Amount,
                OrderAmtEntity_Order = new OrderAmtEntity() { PaymentMethod = orderAmt.PaymentMethod, PaymentAmt = orderAmt.PaymentAmt },
                OrderTime = order.OrderTime,
                PaidTime = order.PaidTime,
                OrderProductEntities = order.OrderProductEntities
            });  
            var xx = queryN.ToList();
            if (xx.First().OrderAmtEntity_Order.PaymentMethod  == null) 
            {
                throw new Exception("unit error");
            }
        }
    }
}


